﻿CREATE TABLE [sacm].[Cita] (
    [IdCita]          INT          IDENTITY (1, 1) NOT NULL,
    [IdPaciente]      INT          NOT NULL,
    [IdSolicitudCita] INT          NULL,
    [IdAgenda]        INT          NULL,
    [FechaCita]       DATE         NOT NULL,
    [HoraCita]        TIME (7)     NOT NULL,
    [IdEstatusCita]   INT          NULL,
    [FechaMod]        DATETIME     NULL,
    [IpMod]           VARCHAR (15) NULL,
    [IdUsuarioMod]    INT          NULL,
    [IdEmpresa]       INT          NOT NULL,
    [IdSucursal]      INT          NOT NULL
);



